<ul class="indextitre">
			  <li><b><b><b>Les derni&egrave;res offres sur <?php echo "<a href=\"".$_GLOBALS['jbsiteurl']."\">".$_GLOBALS['jbsitename']."</a>"; ?></b></b></b>
			  </li>
</ul>
			<?php

				include 'connect_job.php';
				$sql = "SELECT * FROM jobs LIMIT 5"; 
				$result = mysql_query($sql)
					  or die("Exécution requête job impossible"); 


			?>

			<table id="job-posts3" class="job-posts" cellspacing="0">
				<?php

				$i = 0;
				while($job = mysql_fetch_array($result))
				{
				
				?>				
				<tr>
					<td>
						<img src="images/icon-
						<?php switch($job['type_id'])
							{
							case 1: echo "fulltime";break;
							case 2: echo "parttime";break;
							case 3: echo "freelance";break;							
							}
						?>
						.png" />
						<a href="" title="<?php echo $job['title']; ?>"><?php echo $job['title']; ?></a> 
						
					</td>
					<td class="time-posted w90"><img src="./images/clock.gif" alt="" /> <?php echo substr($job['created_on'], 0, 10); ?></td>
				</tr>
				<?php 
				$i++;
				if ( $i == 3 )
				{
					break;
				}
				} ?>
			</table>